package com.merck.service.exportTemp;

import java.util.LinkedHashMap;
import java.util.Map;

public class TempTitleMap {

    public static Map<String, Map<String, String>> getTempTitleMap(String excelName) {
        Map<String,Map<String, String>>  mapTitle = new LinkedHashMap<>();
        Map<String, String> mapField = null;
        if ("FBU".equalsIgnoreCase(excelName)) {
            //sheet FBU_REP_FD_C FD_S FD_P
            mapField = getBaseTitle();
            mapTitle.put("FBU_REP_FD_C FD_S FD_P", mapField);
            mapField.put("art_register_rate", "ART客户注册率");
//            mapField.put("ivf_report_m1", "IVF报告-1");
//            mapField.put("ivf_report_m2", "IVF报告-2");
//            mapField.put("ivf_report_m3", "IVF报告-3");
            mapField.put("product_test", "季度产品知识考试");
            mapField.put("ab_art_register_rate", "ART实验室客户注册率");
            //新增
            mapField.put("lesson_fee_in_time", "讲课费报销及时性");
            mapField.put("lesson_fee_return_rate", "讲课费报销退单率");
            mapField.put("central_area_meetings_m1", "中央区域及销售自办会议次数-1");
            mapField.put("central_area_meetings_m2", "中央区域及销售自办会议次数-2");
            mapField.put("central_area_meetings_m3", "中央区域及销售自办会议次数-3");
            //sheet FBU_DSM_FD_BA
            mapField = getBaseTitle();
            mapTitle.put("FBU_DSM_FD_BA", mapField);
            mapField.put("hospital_warning", "医院预警及时性");
            mapField.put("product_retention", "医院全品规保持率");
            mapField.put("cso_channel_management", "CSO及渠道管理");
            mapField.put("device_dealer_management", "器械经销商管理");
            mapField.put("product_test", "季度产品知识考试得分");
            mapField.put("daily_behavior_m1", "日常行为评分-1");
            mapField.put("daily_behavior_m2", "日常行为评分-1");
            mapField.put("daily_behavior_m3", "日常行为评分-1");
            //FBU_DSM_FD_S FD_C FD_P
            mapField = getBaseTitle();
            mapTitle.put("FBU_DSM_FD_S FD_C FD_P", mapField);
            mapField.put("coaching_quality_m1", "对代表的辅导质量-1");
            mapField.put("coaching_quality_m2", "对代表的辅导质量-2");
            mapField.put("coaching_quality_m3", "对代表的辅导质量-3");
            mapField.put("key_tech_calls_ratio", "对重点Tech客户进行拜访");
//            mapField.put("expense_management", "费用管理");
            mapField.put("art_register_rate", "ART客户注册率");
            mapField.put("bmr_assess", "BMR评估评分");
//            mapField.put("daily_behavior_m1", "销售团队管理上级打分-1");
//            mapField.put("daily_behavior_m2", "销售团队管理上级打分-2");
//            mapField.put("daily_behavior_m3", "销售团队管理上级打分-3");
            mapField.put("product_test", "季度产品知识考试评分");
            mapField.put("ab_art_register_rate", "ART实验室客户注册率");

            mapField.put("phase_breakthrough_speaker_coverage", "阶段性突破中心讲者覆盖");
            mapField.put("rep_meeting_execution_rate", "代表会议执行达标率");
            mapField.put("lesson_fee_in_time_and_return_rate", "代表讲课费报销及时性和退单率");
            //FBU_FT DM_FT
            mapField = getBaseTitle();
            mapTitle.put("FBU_FT DM_FT", mapField);
            mapField.put("procurement_plan", "采购计划及流程跟进");
            mapField.put("key_account_maintain_m1", "关键客户维护-1");
            mapField.put("key_account_maintain_m2", "关键客户维护-2");
            mapField.put("key_account_maintain_m3", "关键客户维护-3");
            mapField.put("combination_score_m1", "联合推动-1");
            mapField.put("combination_score_m2", "联合推动-2");
            mapField.put("combination_score_m3", "联合推动-3");
            mapField.put("activity_execution", "活动执行及市场信息收集");
            mapField.put("nc_team_training", "对NC团队的产品知识培训");
//            mapField.put("product_test", "季度产品知识考试");
            //FBU_RSD&NAD
            mapField = getBaseTitle();
            mapTitle.put("FBU_RSD&NAD", mapField);
            mapField.put("art_register_rate", "ART注册客户占比");
            mapField.put("expense_management", "费用管理");
            mapField.put("turnover_rate", "销售队伍管理评估 -团队人员管理");
            mapField.put("ems_assess", "销售队伍管理评估 -EMS评估");
            mapField.put("transaction_management", "销售队伍管理评估 -事务管理");
            mapField.put("market_share_change", "市场份额变化得分");

            mapField.put("event_execution", "活动执行");
            mapField.put("speaker_coverage", "讲者覆盖");
        } else if ("GBU".equalsIgnoreCase(excelName)) {
            //KPI_GBU_REP_CHD
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_REP_CHD", mapField);
            mapField.put("product_test_m1", "月度产品知识考试-1");
            mapField.put("product_test_m2", "月度产品知识考试-2");
            mapField.put("product_test_m3", "月度产品知识考试-3");
            //KPI_GBU_REP_ST_TD_DB_CV_MIX
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_REP_ST_TD_DB_CV_MIX", mapField);
            mapField.put("vbp_hap", "VBP考核HAP");
            mapField.put("vbp_procurement", "VBP考核医院采购");
            mapField.put("expand_customer", "扩展客户");
            mapField.put("marketing_activities", "市场推广活动评估");
            mapField.put("training_completion", "培训完成及时性");
            mapField.put("product_test", "季度产品知识考试");
            //KPI_GBU_DSM_HA
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_DSM_HA", mapField);
            mapField.put("hospital_warning", "医院预警");
            mapField.put("product_retention", "医院全品规保持率");
            mapField.put("training_completion", "培训完成及时性");
            mapField.put("product_test", "季度产品知识考试 ");
            //KPI_GBU_DSM_ST_TD_DB_CV_MIX_CHD
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_DSM_ST_TD_DB_CV_MIX_CHD", mapField);
            mapField.put("vbp_hap", "VBP考核HAP");
            mapField.put("vbp_procurement", "VBP考核医院采购");
            mapField.put("coaching_quality_m1", "对代表的辅导质量得分-1");
            mapField.put("coaching_quality_m2", "对代表的辅导质量得分-2");
            mapField.put("coaching_quality_m3", "对代表的辅导质量得分-3");
            mapField.put("coaching_quality_q", "辅导质量得分");
            mapField.put("market_access", "市场准入合作得分(ST)/市场推广活动(TD)");
            mapField.put("training_completion", "培训完成及时性得分");
            mapField.put("product_test", "季度产品知识考试 ");
            //sheet KPI_GBU_RSM
            mapField = getBaseTitle();
            mapTitle.put("KPI_GBU_RSM", mapField);
            mapField.put("expense_management", "YTD费用使用率得分");
            mapField.put("regional_promotion", "区域推广执行评估得分");
            mapField.put("vbp_hap", "VBP考核HAP得分");
            mapField.put("vbp_assess", "VBP考核医院采购得分");
            mapField.put("turnover_rate", "YTD离职率得分");
            mapField.put("talent_retaining", "人员保留和招聘评估得分");
            mapField.put("management ability", "管理能力综合评分得分");
        } else if ("KA".equalsIgnoreCase(excelName)) {
            mapField = getBaseTitle();
            mapTitle.put("KPI_KA_DSM_KA", mapField);
            mapField.put("product_test", "季度产品知识考试 ");
        } else if ("OBU".equalsIgnoreCase(excelName)) {
            //KPI_OBU_REP_Erbitux
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_REP_Erbitux", mapField);
            mapField.put("product_test", "季度产品知识考试成绩 ");
            mapField.put("department_meeting_quality_m1", "科室会质量-1");
            mapField.put("department_meeting_quality_m2", "科室会质量-2");
            mapField.put("department_meeting_quality_m3", "科室会质量-3");
            mapField.put("expense_management", "费用管理得分");
            //KPI_OBU_REP_Xalkori
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_REP_Xalkori", mapField);
            mapField.put("joint_promotion_rate", "联合推广医院季度达成率得分 ");
            mapField.put("sample_testing_rate", "独立拜访医院样品检测指标季度达成率得分 ");
            mapField.put("product_test", "季度产品知识考试 ");
            //KPI_OBU_DSM
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_DSM", mapField);
            mapField.put("coaching_quality_m1", "对代表的辅导质量-1");
            mapField.put("coaching_quality_m2", "对代表的辅导质量-2");
            mapField.put("coaching_quality_m3", "对代表的辅导质量-3");
            mapField.put("core_hospital_rate", "核心医院覆盖率");
            mapField.put("ems_rate", "EMS使用率");
            mapField.put("product_test", "季度产品知识考试");
            mapField.put("expense_management", "费用管理得分");
            //KPI_OBU_RSM
            mapField = getBaseTitle();
            mapTitle.put("KPI_OBU_RSM", mapField);
            mapField.put("turnover_rate", "团队季度离职率得分");
            mapField.put("expense_management", "销售费用管理的得分");
            mapField.put("forecast_accuracy", "销售预估准确性得分");
            mapField.put("management_assessment", "销售队伍管理评估得分");
        }
        return mapTitle;
        }

    private static Map<String, String> getBaseTitle() {
        Map<String, String> mapField = new LinkedHashMap<>();
        mapField.put("year", "年");
        mapField.put("quarter", "季度");
        mapField.put("bu", "BU");
        mapField.put("role", "Role");
        mapField.put("position", "Position");
        mapField.put("region_name", "RegionName");
        mapField.put("position_id", "PositionID");
        mapField.put("muid", "MUID");
        mapField.put("name", "姓名");
        mapField.put("parent_name", "上级经理");
        return mapField;
    }
    }
